package jdbc3_25;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class JDBCDemo01 {
    public static void main(String[] args) {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn=DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/tedu" +
                            "?characterEncoding=utf8" +
                            "&useSSL=false" +
                            "&serverTimezone=Asia/Shanghai" +
                            "&rewriteBatchedStatements=true",
                    "root",
                    "root");

            System.out.println("链接数据库成功");

            Statement statement = conn.createStatement();
            String sql = "CREATE TABLE user (\n" +
                    "    id INT PRIMARY KEY AUTO_INCREMENT,\n" +
                    "    password VARCHAR(30) ,\n" +
                    "    nickname VARCHAR(30),\n" +
                    "    age INT(3)\n" +
                    ")";
            statement.execute(sql);
            System.out.println("--------");
            conn.close();

        } catch (Exception e) {
            throw new RuntimeException(e);
        }


    }
}

